<?php
class Servicemanager_Data_Getcurrentservice implements Servicemanager_Data_Mainable{
    
    private $core_controller_selectdata;
    
    public function __construct() {
        $this->core_controller_selectdata = new Core_Controller_Selectdata;
    }

    public function main(array $variables = null) {
        $variables['query'] = "SELECT service_settings.service_name, service_settings.subcategory_name, service_settings.status_name, service_settings.access_level, service_meta_values.service_meta_title, service_meta_values.service_meta_description, service_meta_values.service_meta_keywords, service_content_values.service_title, service_content_values.service_description, service_content_values.service_content, service_content_values.service_image FROM service_settings, service_meta_values, service_content_values WHERE service_settings.service_name = '".$variables['get']['name']."' AND service_settings.service_name = service_meta_values.service_name AND service_settings.service_name = service_content_values.service_name AND service_content_values.service_name = service_meta_values.service_name;";
        //echo $variables['query'];
        //die();
        return $this->core_controller_selectdata->main($variables);
    }

}
